import mysql.connector

conn = mysql.connector.connect(user='root', password='Pass@word',
                               host='localhost', port='3306',
                               database='python', use_unicode=True)
c = conn.cursor()
c.executemany('insert into user_tb values (null ,%s, %s,%s)'
              , (('wk1', '123', 'male')
                 , ('wk2', '123', 'male')
                 , ('wk3', '123', 'male')
                 , ('wk4', '123', 'male')
                 , ('wk5', '123', 'male')))
conn.commit()
c.close()
conn.close()
